--Execute as sys
DROP TABLE customer_profiles_interim;
SELECT segment_name, segment_type, segment_subtype 
FROM dba_segments
WHERE tablespace_name = 'LOB_TBS1'
AND segment_type = 'LOBSEGMENT'
/